home *** CD-ROM | disk | FTP | other *** search
/ Mac Format 1997 January / macformat46.iso / File Maker Pro 3.0 Tutorial / File Maker Pro 3.0 / Templates / FileMaker Examples / Integrated Solution / Line Items (.txt) < prev    next >
FileMaker Pro Database  |  1996-06-20  |  101KB  |  704 lines
  1. HBAM2016AUG95
  2. Pro 3.0
  3. (Hard Disk:British:Extensions:LaserWriter
  4. DUB-Engineering
  5. Lorraine
  6. s Performa 6200
  7.     Hard Disk
  8. Lorraine Smith
  9. SMR Labels ONLY
  10. LaserWriter
  11. SMR Labels ONLY
  12.  0#($
  13. "d%D(
  14. FileMaker Pro V3 British Labels
  15. +++++
  16. ++++++++++++++++++++
  17. MSPC@
  18. HBAM3016AUG95@
  19. bcp132
  20. dp104
  21. gtp139
  22. ocp102
  23. 13H    Last WeekI
  24. 10/15/95...10/21/95
  25. I'll Perform the Find
  26. Pro 3.0F!
  27. Pro 3.0M1
  28. Sunday
  29. Monday
  30. Tuesday
  31.     Wednesday
  32. Thursday
  33. Friday
  34. Saturday
  35. January
  36. February
  37. March
  38. April
  39. August
  40.     September
  41. October
  42. November
  43. December
  44. 1st Quarter
  45. 2nd Quarter
  46. 3rd Quarter
  47. 4th Quarter
  48. DP104C
  49. Deer PosterD
  50. 12.00F
  51. OCP102C
  52. Oregon Coast PosterD
  53. 12.50F
  54. BCP132C
  55. Brookings Coast PosterD
  56. GTP139C
  57. Ghost Town PosterD
  58. 33.00F
  59. GTP139C
  60. Ghost Town PosterD
  61. 33.00F
  62. OCP102C
  63. Oregon Coast PosterD
  64. 12.50F
  65. 6/20/96
  66. DESCRIPTION
  67. INVOICE ID
  68. LINE ITEM TOTAL
  69. PRICE
  70. PRODUCT ID
  71. QUANTITY
  72. REPORT NAME
  73. SEARCH PERIOD
  74. SEARCH PERIOD REPORT
  75. TOTAL LINE ITEM
  76. TOTAL QUANTITY
  77. TOTAL RECORDS
  78. Invoice IDB
  79. Product IDB
  80. DescriptionB
  81. QuantityB
  82. PriceB
  83. Line Item TotalB
  84. Total RecordsB
  85. Search PeriodB
  86. Search Period ReportB
  87. Total Line ItemB
  88. Total QuantityB
  89. Report NameB
  90. I'll Perform the FindL
  91. Invoice 20
  92. Report Menu
  93. Find Dialog
  94. Summarize by Month
  95. Summarize by Day
  96. Summarize by Week
  97. Summarize by Year
  98. View as List
  99. Report MenuB
  100. Find DialogB
  101. Reports
  102. Main 
  103. ReportsV
  104. Summarize
  105. by DayW
  106. Summarize
  107. by WeekX
  108. Summarize
  109. by MonthY4Creating reports is quite easy and requires 3 steps:Z
  110. 3.  Select the report below.[
  111. Find Your Own\3There is currently <<
  112. ABAH>> selected Line Item(s).]B1.  Find the Invoices that you would like to create a report with.^
  113. Your Own Reporta:Select the correct search request or Find Your Own Recordsb
  114. Summarize
  115. by Yearc
  116. 2.  Name your report. 
  117. Summarize by MonthB
  118. Main 
  119. Entry
  120. View as
  121. Reports
  122. Invoice
  123. Find a Line Item
  124. Product ID
  125. Price
  126. Description
  127. Quantity
  128. Cancel
  129. Invoice
  130. Invoice Date
  131. Summarize by DayB
  132. Product IDF
  133. DescriptionH
  134. QuantityW
  135. Summary Report by Month[
  136.  Search Range:  <<
  137. ABAJ>>h
  138. Total Line Itemi
  139. Printed //j
  140. Printed by <<
  141. AFAAABAEABAB>>k
  142. Page ##u
  143. AFAAABADABAB>> totals:v
  144. Grand Totalw    <<
  145. ABAM>>
  146. Summarize by WeekB
  147. Product IDF
  148. DescriptionH
  149. QuantityW
  150. Summary Report by Day[
  151.  Search Range:  <<
  152. ABAJ>>h
  153. Total Line Itemi
  154. Printed //j
  155. Printed by <<
  156. AFAAABAEABAB>>k
  157. Page ##u
  158. AFAAABADABAB>> totals:v
  159. Grand Totalw    <<
  160. ABAM>>
  161. Summarize by YearB
  162. Product IDF
  163. DescriptionH
  164. QuantityW
  165. Summary Report by Week[
  166.  Search Range:  <<
  167. ABAJ>>h
  168. Total Line Itemi
  169. Printed //j
  170. Printed by <<
  171. AFAAABAEABAB>>k
  172. Page ##u!Week of <<
  173. AFAAABADABAB>> totals:v
  174. Grand Totalw    <<
  175. ABAM>>
  176. View as ListB
  177. Product IDF
  178. DescriptionH
  179. QuantityW
  180. Summary Report by Year[
  181.  Search Range:  <<
  182. ABAJ>>h
  183. Total Line Itemi
  184. Printed //j
  185. Printed by <<
  186. AFAAABAEABAB>>k
  187. Page ##u
  188. AFAAABADABAB>> totals:v
  189. Grand Totalw    <<
  190. ABAM>>
  191. This database file is used by the Invoices file to store products purchased for an invoice.  To enter a line item for an invoice, open the Invoices database and type the product ID.V
  192. Line Items
  193. Main 
  194. X:Line Items - line items are entered from Invoices database
  195. Return
  196. to Invoices
  197. Invoice ID\
  198. Product ID]
  199. Description^
  200. Quantity_
  201. Price`
  202. Line Item Total
  203. Summarize by Day
  204. Preview or Print
  205.  "Preview")
  206. PreviewGB9
  207.  "Print")
  208. PrintG
  209. Summarize by Week
  210. Summarize by Month
  211.  "I'll Perform the Find"
  212. I'll Perform the Find
  213.  = "Last Week"
  214.            
  215. b)-1)-7) & "..." &
  216.                 
  217. b+ (7 - 
  218. b)-7))
  219.  = "This Week"
  220.            
  221. b)-1)) & "..." &
  222.                 
  223. b+ (7 - 
  224.  = "Last Month"
  225.              
  226. b))) & "..." & 
  227.                 
  228. b)) -1)
  229.  = "This Month"
  230.              
  231. b))) & "..." & 
  232.           
  233.       
  234. b) + 1
  235. b)) -1)
  236.  = "Last Year"
  237.             "1/1/" & (
  238. )) -1) & "..." & 
  239.                "12/31/" & (
  240. ))-1)
  241.  = "This Year"
  242.            "1/1/" & 
  243. )) & "..." & 
  244.                "12/31/" & 
  245.  = "I'll Perform the Find"
  246.     Last Week
  247.     This Week
  248. Last Month
  249. This Month
  250.     Last Year
  251. 1/1/    
  252. 12/31/
  253.     This Year
  254. 1/1/    
  255. 12/31/
  256. I'll Perform the Find
  257. ) = 0    
  258. Cancel
  259. :;<=>?@ABCDE
  260.  "#+./345>ABCGIL
  261. &*268:H
  262. There are no records that match your reports find request.H
  263. Cancel
  264. ADDFIELDSHRINKAGE
  265. Please Select a find request.
  266.  JJJJ
  267. !BBBB
  268. "99BB
  269. #9999
  270. $9911
  271. %1111
  272. &))))
  273. '!!!!
  274. Summarize by Year
  275. Find from Report
  276. "I'll Perform the Find"
  277. I'll Perform the FindB
  278. Your Own Script
  279. Create your own script andB
  280. attatch it to a button
  281. Go to Invoices
  282. Your Own Script
  283. Go to Main Menu
  284. Go to Reports Menu
  285. Go to Invoices
  286. Preview or Print
  287. Perform Find
  288. Summarize by Day
  289. Summarize by Week
  290. Summarize by Month
  291. Summarize by Year
  292. Find from Report
  293. Go to Main Menu
  294. Go to Reports Menu
  295. Perform Find
  296. wwwwww
  297.     ffffff
  298. UUUUUU
  299. DDDDDD
  300. 333333
  301. """"""
  302. #11#22122"3!
  303. "#""3"129
  304. C3C3C34C4C3CC43C
  305. DDCD4DD4CDDC
  306. 4CDD4E4ET
  307. TEETEETUETUETUDUDEETUDTUE[
  308. UTdUTeETeETeEUFTUTUFTUUTeK
  309. EUeFFEUFEUFFUeTeVFeUUdVEEk
  310. ffFdeefeefddfDeVdfEdfFdffk
  311. eVefefe
  312. VvffVefVVefUe\
  313. fvfgfwffv
  314. ggvgvv
  315. gvwxgwghg
  316. vhgvvww
  317. wwxwwxw
  318.  *00**-
  319. *00-00 
  320. 00*0)
  321. 00*&0#
  322. ## !0*!%00+#!*0##-0'"0*#%00.!
  323. QMSPC
  324. FPTHAQDaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:products.fp3
  325. MSPCA
  326. NAMEA
  327. products.fp3
  328. RPTHA
  329. products.fp3
  330. SRPTA
  331. products.fp3
  332. OMSPC
  333. FPTHAOAPS Drive
  334. :Projects:Franz Project:FM Pro Solution:13-More Changes:Main Menu.fp3
  335. MSPCA
  336. NAMEA
  337. Main Menu.fp3
  338. RPTHA
  339. Main Menu.fp3
  340. SRPTA
  341. main_mnu.fp3
  342. OMSPC
  343. FPTHAOAPS Drive
  344. :Projects:Franz Project:FM Pro Solution:15-More Changes:Main Menu.fp3
  345. MSPCA
  346. NAMEA
  347. Main Menu.fp3
  348. RPTHA
  349. Main Menu.fp3
  350. SRPTA
  351. main_mnu.fp3
  352. NMSPC
  353. FPTHANAPS Drive
  354. :Projects:Franz Project:FM Pro Solution:15-More Changes:invoices.fp3
  355. @@BA@
  356. wwwwww
  357.     ffffff
  358. UUUUUU
  359. DDDDDD
  360. 333333
  361. wwwwww
  362.     ffffff
  363. UUUUUU
  364. DDDDDD
  365. 333333
  366. wwffeffg@
  367. veUEDDCC
  368. vUTDD44
  369. vUDDC32
  370. #""# 
  371. weUDD3
  372. veTDC2233#3#2
  373. wUDDC3##"
  374. vUTD3#22
  375. vUDDC
  376. fUD42233##3#"!
  377. vTDCC##"
  378. eUDC3223##
  379. fTD4C3##23#""
  380. uTDC3323#2""!
  381. 22"2"
  382. ##2"!
  383. fTDD33#22""
  384. vUDC32"2""
  385. WUTC22
  386. eTD3#""
  387. GDC32"!!
  388. eD3#"!
  389. T32""
  390. #4EWp
  391. "4EVx
  392. #3EVg
  393. "4DUg
  394. #3EVg
  395. "#4DVg
  396. 24EVgy
  397. "34EVw
  398. ##4Efw
  399. ""3DUgw
  400. ""33DUfw
  401. ""34DVgx
  402. ""#34EVgx
  403. "#33DEfw
  404. "    234DUfw
  405. 2""2334DEVgx
  406. 3    4DEUfwx
  407. 3    DDUVgw
  408. D    EUUfwx
  409. UDDEUUfgw
  410. U    Vfgwx
  411. eUVfgww
  412. UUUUUU
  413. wwwwww
  414. (*)(%,3&    
  415. )%+@6) 
  416. ",30,)%
  417.  #*>A6332+$"!
  418. 25,878
  419. #&$690*"
  420. !)0,++)(
  421.  "%/66435/'#
  422. +3;4*=
  423. !#,@9,)+,(""(-/,,*
  424. !$&(265389,#!$$
  425. '275?
  426. " $$*23/$
  427. $),-..)''
  428. !$&)(-5439@1!!&*-3/)!!%6B)
  429. )220(!$*.,,.' 
  430. !$&*,*023:?B+*.,/3254.'
  431. "++,3/(.584.,"
  432. !#&+/-./3:9@G@60/16883)!
  433. $++//'(9CD>4.$$
  434. $%)*-//2693,.075-&)3792,$
  435. ")-1347<>@G71(!
  436. **)&'*.0350+%(=A2'%)579<94(
  437. +/11!
  438. !%'),342)1?=0)"
  439. .1,$',-01)*).AG6-/048:<
  440. /2583$%+66/%
  441.  %)++*),+&%06,%$#
  442. !/40')-/31$$,@HFC<6887:==@B7%!
  443. 6A235,% 
  444. +,/13.%#"(16+
  445. !#$(04-$&+,+$
  446. %2>D6,59:989889=0
  447. ,.22<=33*
  448. .22671#
  449. !!&/42&
  450. *1$&+,/3779733,
  451.  $$PQ
  452. /004B6*
  453. !$$ $))'/3)
  454. %&$&.7;4
  455. )2$)*3-)466/%$
  456. !),02+'
  457. %$5)%*+%$!
  458. (+'0:==4
  459. $+,,1643"%)"
  460. !)/1)*+
  461. +7=-%%&$!
  462. !3)3=.
  463. %&*/3113
  464.  !$$PQ
  465. ',4-%)/)
  466. ,6/%$$" 
  467. +(!<-
  468. %),0354-
  469. .13-&,-*
  470. 14'$$! 
  471. %))&%$!
  472. '3*$$" 
  473. !&$%3
  474. &%"%&
  475. 9836'
  476. )&#%%!
  477. $*)++"
  478. .-/:%
  479. !"&)()15,
  480. )" /.-+)!
  481. //6B&
  482.  #'*,.42$
  483. $/,-*%
  484. IF1A1
  485. "%.2/-*#!
  486. $/.,*($!#$"%PQ
  487. #57-*'$#"$&'
  488. ..//.-,)'(.212PQ
  489. ",,)&%'.;<6/+',,)%!
  490. '//,+//*)+.4:=>PQ
  491. $(&(),5?@:2/,,''*$
  492. -!,,%.0%)./7
  493. #43((+9CA=3+,)+"
  494. &*)2!$96;;48@??PQ
  495. )/01%$
  496. #3/').:@<3)$&)!
  497. /)4$%)8=A@?><@PQ
  498. !.0/.+//./1//*
  499. *.').3784/%
  500. ,,#%()25:<99=PQ
  501. %10//
  502. 0 /+134,.25653."
  503. )++-!
  504. # %0,*,384'%PQ
  505. 42//11/&(/563135650(
  506. (./36$
  507. !"23.,27- 
  508. 6:=<)&931-13-!$.69433563+
  509. ,/258 #$,96-37)$!PQ
  510. 38;?B>;63/.22.-068934673(
  511. ,638<6$
  512. *),/6."')==138*$)PQ
  513. 35:=@B>953-/1.-368<:8995&
  514. %668:9(
  515. )$'*.:&$*==8/,
  516. -19=@CA>:83+2.,0157:
  517. !""/88$
  518. !)*# 6/0%&' !$*38,.<;60"
  519. +07=@CD=6>@.*)&(*-03;@@<-
  520. 6.3/%
  521. #/23989=2,*%
  522. /039>B@ "9E7,)+/3667:?CE/!"
  523. $$%199207/
  524. 9K8@)
  525. 3933"
  526. !0042381%$(.-)56PQ
  527. 556:=@@
  528. 5C958=BGGA96;='"+-
  529. !!%.94.6BDCFM='(204967&
  530. //2346%
  531. $59232$PQ
  532. :9<@?@C% 6D;;CJLONG952
  533. (9304=FCDDE>%
  534. $,585'
  535. !.//11'$/;81$
  536. 9:CE><D3,5G@@HF>IF94)
  537. $#%+*159C=:>FG)
  538. *31*#
  539. $/51#
  540. 89C=.!:9=C<9AFGCA7&(
  541. /%3%!'+5A<6=C>$
  542. -672.3<<961.%!
  543. ,,%=<9/69/02. 
  544. "773//33/,+)
  545. /1$'9<
  546. 069850(*)'%
  547. %/+$ 
  548. !&##34
  549. %0<PQ
  550. %"$:C9.*$
  551. !+6@PQ
  552. "$$6CD>>5
  553. !##()
  554. ".;CPQ
  555.  %'0>GFA:378+&&%$$,&
  556. ,:CPQ
  557. $(,027CGG@6681//,)%$/
  558. '7CPQ
  559. !%*/1,/44CC;6547@=2*!%.$
  560. %;CPQ
  561. '$)=3
  562.  #%)*())3DLHB
  563. ?MB9/% !
  564. "'6?6$
  565. *;=PQ
  566. $%&,9D6
  567. !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
  568. !)/38;@(
  569. "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
  570. +/0,$%&%%,26:5)
  571. "$%&(/7;<=BGIJIGMG=953'%(1<<63/!
  572. $*.8PQ
  573. 876=@?<3),3:8$
  574. !&((),3=;::=EHIC:<F3)'""#&+/,',
  575. #&(0PQ
  576. FC8:CF@7/08<(
  577. "'()*,
  578. 169?:6=C=2..3'"
  579. "%&)PQ
  580. HD99=A@9534/
  581. !26(%5, 
  582. ! !),''*-16<@=430/,+/)!
  583. ??979>@@:-!
  584. !$+%-*),/37<@:2/-*)+*" 
  585. 4?=95;@@9&
  586. *#%.,/136884/,)'),,%)+(%$$
  587. />C:13?@9)$ 
  588. !!89+
  589. !)$%*-/13321/,*3*)-/0/+&$$!
  590.  6A:0,8B=1+)/68.%/(,9=2%
  591. ")$"%)-02331/31)/().241+%##!
  592. *79/)/:<651/33)2<8.6=9. 
  593. !$%,56643/75,'&).340+&#!$$%#!
  594. .5.)/46682%#$$-973:=<7)
  595. !$'+4:964063+(
  596. ,33/+(&'),*)'#
  597. "%%.2379:1&"%(&.36@?@D5 
  598. !$%')/8:86>=2)&!!-231
  599. 34772+*
  600.  &46339C@4+,3/)/:<D/8J='
  601. "%'))+336@3(/)%#%,34569<=?CE5,)!
  602.  #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
  603. #,0258<?ADGE2 "'(#
  604. "%),,/6983$
  605. &4<9+4DD>?J>/*-6;<6,,/25.))3,'
  606. ",.0369;=AGE.
  607. !%%(,.040'
  608. 2A?EA4*+/683*.493/($!/-,
  609. 0246689:AC7%
  610. $%##(.23&
  611. :96,#"%)*(%(364,
  612. M4%"!!"560&)/<9;989;>3$
  613. "03., PQ
  614. DDDDDD
  615. B"#B0
  616. B"#B"$
  617. "2#B"#B"#@
  618. 2$""#B"#@
  619. "2#B"#@
  620. 2$B"#@
  621.     B220
  622. DDDDDD
  623. wwwwww
  624. ffffff
  625. 333333
  626. """"""
  627. DDDDDD
  628. ~ffff
  629. ffffff
  630. ffff33
  631. ff33ff
  632. ff3333
  633. 33ffff
  634. 33ff33
  635. 333333
  636. wwwwww
  637. UUUUUU
  638. DDDDDD
  639. """"""
  640. NAMEA
  641. invoices.fp3
  642. SRPTA
  643. invoices.fp3
  644. ZONEA
  645. (LIST
  646. LISTAYLast Week
  647. This Week
  648. Last Month
  649. This Month
  650. Last Year
  651. This Year
  652. I'll Perform the Find
  653. VDEFA(
  654. Search Values
  655. FMRLA
  656. FMRLA
  657. FMRLA
  658. FMRLA
  659. ProductsB
  660. GlobalsC
  661. InvoicesD    Main Menu
  662. MSPCA
  663. NAMEA
  664. invoices.fp3
  665. RPTHA
  666. invoices.fp3
  667. SRPTA
  668. invoices.fp3
  669.     Helvetica
  670. Geneva
  671. Times
  672.  JJJJ
  673. !BBBB
  674. "99BB
  675. #9999
  676. $9911
  677. %1111
  678. &))))
  679. '!!!!
  680. 13H    Last WeekI
  681. 10/15/95...10/21/95
  682. Pro 3.0F!
  683. Pro 3.0M1
  684. Sunday
  685. Monday
  686. Tuesday
  687.     Wednesday
  688. Thursday
  689. Friday
  690. Saturday
  691. January
  692. February
  693. March
  694. April
  695. August
  696.     September
  697. October
  698. November
  699. December
  700. 1st Quarter
  701. 2nd Quarter
  702. 3rd Quarter
  703. 4th Quarter
  704.